Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
1.
|
To start a new line in a cell, press ____ after each line, except for the last
line, which is completed by clicking the Enter box, pressing the ENTER key, or pressing one of the
arrow keys.
a. | ALT+ENTER | c. | SHIFT+ENTER | b. | CTRL+ENTER | d. | TAB+ENTER |
|
|
|
2.
|
To save a previously saved workbook with a new name or on a different drive,
____.
a. | click the Save button on the Quick Access Toolbar | b. | click Save As on the
File menu | c. | press CTRL+S | d. | click Save on the File
menu |
|
|
|
3.
|
All of the following are valid Excel arithmetic operators except
____.
|
|
|
4.
|
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals
____.
|
|
|
5.
|
Using the ____ button on the Ribbon instructs Excel to display additional
decimal places in a cell.
a. | AutoFormat | c. | Increase Decimal | b. | Currency Style | d. | Percent Style |
|
|
|
6.
|
Click ____ in the Conditional Formatting gallery to display the New Formatting
Rule dialog box.
a. | Rule Format | c. | New Format | b. | New Rule | d. | Format Rule |
|
|
|
7.
|
When Excel starts and the blank worksheet displays on the screen, all of the
columns have a default width of ____.
a. | 8.43 characters, or 64 pixels | c. | 12.75 points, or 17
pixels | b. | 64 characters, or 8.43 pixels | d. | 17 points, or 12.75
pixels |
|
|
|
8.
|
To toggle between the values version and the formulas version of a worksheet,
hold down the ____ key.
a. | ALT key while pressing the ACCENT MARK (`) | b. | ALT key while
pressing the SINGLE QUOTATION MARK (') | c. | CTRL key while pressing the ACCENT MARK
(`) | d. | CTRL key while pressing the SINGLE QUOTATION MARK
(') |
|
|
|
9.
|
The formulas version verifies that you entered formulas, rather than ____, in
formula-based cells.
a. | text | c. | functions | b. | numbers | d. | dollar signs |
|
|
|
10.
|
The ____ of the worksheet shows the actual formulas you have entered, rather
than the resulting values.
a. | Actual symbol | c. | formulas version | b. | current version | d. | Formulas Print
symbol |
|
|
|
11.
|
To import data stored on a Web site use a ____.
a. | Web query | c. | Web import | b. | Web search | d. | Web copy |
|
|
|
12.
|
What name does Excel give the first blank worksheet?
a. | Book1 | c. | Worksheet1 | b. | Workbook1 | d. | Sheet1 |
|
|
|
13.
|
To rename sheets, double-click the sheet tab in the lower-left corner of the
window, type the new sheet name, and then ____.
a. | click the Cancel box | c. | click the Name box | b. | press the ESC key | d. | press the ENTER
key |
|
True/False
Indicate whether the
statement is true or false.
|
|
|
14.
|
The arithmetic operator, ^, directs Excel to perform the division
operation.
|
|
|
15.
|
When a formula is copied, Excel adjusts the cell references so the new formulas
contain references corresponding to the new location and performs calculations using the appropriate
values.
|
|
|
16.
|
The Comma Style button is located on the Ribbon.
|
|
|
17.
|
The default row height in a blank worksheet is 12.75 points (or 17
pixels).
|
|
|
18.
|
To skip correcting a word identified by the spell checker, click the Ignore Once
button in the Spelling dialog box.
|
|
|
19.
|
If a cell other than cell A1 is selected before starting the spell checker,
Excel will display a dialog box when the spell checker reaches the end of the worksheet, asking if
the spell checker should continue checking at the beginning.
|
|
|
20.
|
To import external data from a World Wide Web site, it is necessary to have
access to the Internet.
|
Matching
|
|
|
Identify the letter of the choice that best matches the phrase or
definition. a. | Web query | f. | smart tag | b. | order of
operations | g. | function | c. | arguments | h. | pixel | d. | theme | i. | debugging | e. | condition | j. | spell checker |
|
|
|
21.
|
Used for importing into Excel data that is stored on a Web site.
|
|
|
22.
|
When more than one arithmetic operator is involved in a formula, Excel follows
an order from left to right in a formula calculation.
|
|
|
23.
|
A predefined set of colors, fonts, chart styles, cell styles, and fill effects
that can be applied to an entire workbook.
|
|
|
24.
|
A dot on the screen that contains a color and its size is based on the
screen’s resolution.
|
|
|
25.
|
Compares words on the worksheet to words contained in its standard
dictionary.
|